Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Complete syntax reference for Run Stored-Procedure

The following syntax shows the RUN STORED-PROC statement and all options that can be used with the statement. However, keep in mind that not all options shown can be used simultaneously.

Syntax

RUN STORED-PROCEDURE procedure-name [[LOAD-RESULT-INTO <handle> [<int> = PROC-STATUS]]|      [<int> = PROC-HANDLE]]      [ NO-ERROR ]     [([INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression, ...         [INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression )]

Note: In the RUN STORED-PROCEDURE syntax, note that the <handle> is either a pure handle or a handle that points to a temp-table. For more information about using the temp-table handle with the LOAD-RESULT-INTO phrase, see the "LOAD-RESULT-INTO phrase" section.

Syntax

CLOSE STORED-PROCEDURE procedure-name [ integer-field = PROC-STATUS ] [ WHERE PROC-HANDLE = integer-field ]

The CLOSE STORED-PROCEDURE is not used when the LOAD-RESULT-INTO keyword is used with the RUN STORED-PROCEDURE statement. See the "CLOSED STORED-PROCEDURE statement" section.

See these sections for valid combinations and usage of these syntax elements:

"Run Stored-Proc statement execution without the LOAD-RESULT-INTO phrase" section.
"Run Stored-Proc statement execution with the LOAD-RESULT-INTO phrase" section.
"Run Stored-Proc statement with send-sql-statement option" section.

The following sections describe the syntax elements and options in detail. This section also presents examples that describe typical situations in which you might use the various options that the RUN STORED-PROC statement supports.